<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>Performance Tips</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="HOME"
TITLE="PostgreSQL 9.1.2 Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="The SQL Language"
HREF="sql.html"><LINK
REL="PREVIOUS"
TITLE="Locking and Indexes"
HREF="locking-indexes.html"><LINK
REL="NEXT"
TITLE="Using EXPLAIN"
HREF="using-explain.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"><META
NAME="creation"
CONTENT="2011-12-01T22:07:59"></HEAD
><BODY
CLASS="CHAPTER"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
><A
HREF="index.html"
>PostgreSQL 9.1.2 Documentation</A
></TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
TITLE="Locking and Indexes"
HREF="locking-indexes.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="sql.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="20%"
ALIGN="right"
VALIGN="top"
><A
TITLE="Using EXPLAIN"
HREF="using-explain.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="CHAPTER"
><H1
><A
NAME="PERFORMANCE-TIPS"
></A
>Chapter 14. Performance Tips</H1
><DIV
CLASS="TOC"
><DL
><DT
><B
>Table of Contents</B
></DT
><DT
>14.1. <A
HREF="using-explain.html"
>Using <TT
CLASS="COMMAND"
>EXPLAIN</TT
></A
></DT
><DT
>14.2. <A
HREF="planner-stats.html"
>Statistics Used by the Planner</A
></DT
><DT
>14.3. <A
HREF="explicit-joins.html"
>Controlling the Planner with Explicit <TT
CLASS="LITERAL"
>JOIN</TT
> Clauses</A
></DT
><DT
>14.4. <A
HREF="populate.html"
>Populating a Database</A
></DT
><DD
><DL
><DT
>14.4.1. <A
HREF="populate.html#DISABLE-AUTOCOMMIT"
>Disable Autocommit</A
></DT
><DT
>14.4.2. <A
HREF="populate.html#POPULATE-COPY-FROM"
>Use <TT
CLASS="COMMAND"
>COPY</TT
></A
></DT
><DT
>14.4.3. <A
HREF="populate.html#POPULATE-RM-INDEXES"
>Remove Indexes</A
></DT
><DT
>14.4.4. <A
HREF="populate.html#POPULATE-RM-FKEYS"
>Remove Foreign Key Constraints</A
></DT
><DT
>14.4.5. <A
HREF="populate.html#POPULATE-WORK-MEM"
>Increase <TT
CLASS="VARNAME"
>maintenance_work_mem</TT
></A
></DT
><DT
>14.4.6. <A
HREF="populate.html#POPULATE-CHECKPOINT-SEGMENTS"
>Increase <TT
CLASS="VARNAME"
>checkpoint_segments</TT
></A
></DT
><DT
>14.4.7. <A
HREF="populate.html#POPULATE-PITR"
>Disable WAL Archival and Streaming Replication</A
></DT
><DT
>14.4.8. <A
HREF="populate.html#POPULATE-ANALYZE"
>Run <TT
CLASS="COMMAND"
>ANALYZE</TT
> Afterwards</A
></DT
><DT
>14.4.9. <A
HREF="populate.html#POPULATE-PG-DUMP"
>Some Notes About <SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
></A
></DT
></DL
></DD
><DT
>14.5. <A
HREF="non-durability.html"
>Non-Durable Settings</A
></DT
></DL
></DIV
><P
>   Query performance can be affected by many things. Some of these can
   be controlled by the user, while others are fundamental to the underlying
   design of the system.  This chapter provides some hints about understanding
   and tuning <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> performance.
  </P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="locking-indexes.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="using-explain.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Locking and Indexes</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="sql.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Using <TT
CLASS="COMMAND"
>EXPLAIN</TT
></TD
></TR
></TABLE
></DIV
></BODY
></HTML
>